Specify which fields should be excluded when copying data from a Ditto record.
Description
With the Ditto Skip Columns Registry entry it is possible to specify that certain fields are excluded when copying data from a Ditto record. In other words, when Ditto All Fields (SHIFT+F9) and Ditto Current Tab (CTRL+SHIFT+F9) are used to copy values from the Ditto record into the current record, values in the fields listed in this Registry entry will not be copied from the Ditto record into the current record. This entry is used to exclude fields that should always be unique, e.g. Accession Number.
Note:
This entry does not apply to Ditto Current Field (F9) as it is assumed that the user intentionally selects a field to copy: fields listed in a Ditto Skip Columns Registry entry can be copied directly into a field from a Ditto record into the current record. As expected however, if the field is configured to hold unique values and the value copied into it is not unique, it will not be possible to save the value.
By default the following fields are ignored by EMu for all modules: irn, AdmInsertedBy, AdmDateInserted, AdmTimeInserted, AdmDateModified, AdmTimeModified, AdmImportIdentifier, AdmSystemIdentifier and AdmModifiedBy.
Usage
This Registry entry can be assigned to users and groups:
| Key | User | User | Group | Group | Group | Group |
|---|---|---|---|---|---|---|
| Key 1 | User
|
User
|
Group
|
Group
|
Group
|
Group
|
| Key 2 | user | user | group | group | Default
|
Default
|
| Key 3 | Table
|
Table
|
Table
|
Table
|
Table
|
Table
|
| Key 4 | table | Default
|
table | Default
|
table | Default
|
| Key 5 | Ditto Skip Columns
|
|||||
| Value | column;column... | |||||
In pipe-delimited format:
User
|
user | Table
|
table | Ditto Skip Columns
|
column;column... |
User
|
user | Table
|
Default
|
Ditto Skip Columns
|
column;column... |
Group
|
group | Table
|
table | Ditto Skip Columns
|
column;column... |
Group
|
group | Table
|
Default
|
Ditto Skip Columns
|
column;column... |
Group
|
Default
|
Table
|
table | Ditto Skip Columns
|
column;column... |
Group
|
Default
|
Table
|
Default
|
Ditto Skip Columns
|
column;column... |
where:
|
column;column... |
is a semicolon separated list of columns that will not be copied when a record is used as a Ditto record. |
Example
This entry specifies fields in the Parties module that will not be copied when a Parties record is used as a Ditto record:
| Key | Setting |
|---|---|
| Key 1 | Group
|
| Key 2 | Default
|
| Key 3 | Table
|
| Key 4 | eparties
|
| Key 5 | Ditto Skip Columns
|
| Value | NamBusiness_tab;NamMobile;NamFax;NamHome;NotNotes
|
